The Dissect Receipts group of fields on the Config GL Interface screen allows you to customise the integration of goods received and stock to the General Ledger. It also allows for multiple Stock on Hand control accounts in the Balance Sheet of the General Ledger.
To complete the Dissect Receipts fields:
Refer to "Edit - General Ledger Config - Distribution Interface".
Micronet displays the Dissect Receipts fields.
Dissect Receipts
Select an integration option:
|
Option |
Description |
|
Total |
The Distribution system searches for a GL interface record labelled TOTAL and produces accounting entries (financial transactions) based on the GL accounts entered in that table. This is the standard, multi-purpose GL interface record setup to accumulate financial transactions where customisation is not required. |
|
Combination |
Ungreys the fields below (Warehouse Key, Item Key and Supplier Key) allowing you to select exactly how you want receipt transactions dissected. This allows data to be transferred from the Distribution system based on the interrelations between the files that comprise your permanent records. For an example of how the Combination option works, refer to "Configuring MDS Integration". |
Where multiple warehouses exist, Stock on Hand can be divided into separate GL accounts in the Balance Sheet of the General Ledger.
Warehouses can be dissected and reported in one of the following ways:
|
Option |
Description |
Example |
GL Interface |
Master file update |
||||||||||||||||||||
|
None |
No dissection by warehouse |
-- |
-- |
-- |
||||||||||||||||||||
|
Ware(house) Item |
During goods receiving, Micronet determines the relevant warehouse on a line-by-line basis. This occurs where items are being received from suppliers into diverse warehouses, but on the same delivery docket or invoice. |
Both items are received on the same invoice.
Micronet ensures that the items update the individual Stock on Hand GL accounts in the General Ledger:
|
GL interface records need to be setup and assigned to each inventory item |
Inventory master file - GL Interface field (refer to "File - Inventory - Item") |
||||||||||||||||||||
|
Warehouse |
Determines the warehouse on an invoice-by-invoice basis. This occurs where suppliers are invoicing warehouses separately for goods. |
Both items are received in different locations with a separate supplier invoice.
Micronet updates the Stock on Hand in the General Ledger in the prescribed format:
|
GL interface records need to be setup and assigned to each warehouse record |
Warehouse master file - GL Interface field (refer to "File - Warehouse - Warehouse") |
Item Key
Stock on Hand can be divided into various GL accounts in the General Ledger based on the individual items that exist within the inventory files.
Items can be dissected and reported in one of the following ways:
|
Option |
Description |
GL Interface |
Master file update |
|
None |
No dissection by item key |
-- |
-- |
|
Item |
As each item is received into stock, Micronet updates the individual Stock on Hand GL accounts setup in the General Ledger based on the item's assigned GL interface record. |
GL interface records need to be setup and assigned to each inventory item |
Inventory master file - GL Interface field (refer to "File - Inventory - Item") |
|
Category |
As each item is received into stock, Micronet updates the Stock on Hand GL accounts setup in the General Ledger based on each item's product category. |
GL interface records need to be setup and assigned to each product category |
Product Category master file - GL Interface field (refer to "File - Product Category - Category") |
|
Barcode |
As each item is received into stock, Micronet determines the barcode assigned to the item and updates the individual stock accounts in the General Ledger based on this dissection. |
GL interface records need to be setup and assigned to each inventory item |
Inventory master file - GL Interface field (refer to "File - Inventory - Item") |
Supplier Key
Stock on Hand can be dissected and transferred into multiple GL accounts in the General Ledger based on supplier classifications.
Suppliers (creditors) can be dissected and reported in one of the following ways:
|
Option |
Description |
GL Interface |
Master file update |
|
None |
No dissection by supplier |
-- |
-- |
|
Supplier |
As each supplier's invoice is entered through the Goods Received program, Micronet produces accounting journal entries (financial transactions) for Stock on Hand classifications based on individual suppliers or supplier types. |
GL interface records need to be setup and assigned to individual supplier records |
Supplier master file - GL Interface field (refer to "File - Supplier - Supplier") |